If the specified cell is part of an array, returns a Range object that represents the entire array. Results in a run-time error if the specified cell is not part of an array. Read-only.
expression.CurrentArray
expression Required. An expression that returns a Range object.
Use the HasArray property to determine whether or not a cell is part of an array.
Assuming that the active cell is part of an array, this example selects the array.
Spreadsheet1.ActiveCell.CurrentArray.Select